using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VKAAUF
    {
        public DataRow Convert2KAAUF(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryKAAUF(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
         dwReturn["KAAMANDANT"] = " ".PadRight(2 ); 
         dwReturn["KAAKANR"] = " ".PadRight(8 ); 
         dwReturn["KAAKAPOS"] = " ".PadRight(4 ); 
         dwReturn["KAAAENZL"] = " ".PadRight(0 ); 
         dwReturn["KAAAENB"] = " ".PadRight(8 ); 
         dwReturn["KAAAEND"] = " ".PadRight(0 ); 
         dwReturn["KAANEUB"] = " ".PadRight(8 ); 
         dwReturn["KAANEUD"] = " ".PadRight(0 ); 
         dwReturn["KAAKZENTW"] = " ".PadRight(1 ); 
         dwReturn["KAASTATUS"] = " ".PadRight(1 ); 
         dwReturn["KAAVERFA"] = " ".PadRight(1 ); 
         dwReturn["KAAPSEUDO"] = " ".PadRight(1 ); 
         dwReturn["KAAURKANR"] = " ".PadRight(8 ); 
         dwReturn["KAAURKAPOS"] = " ".PadRight(4 ); 
         dwReturn["KAAZWECK"] = " ".PadRight(5 ); 
         dwReturn["KAAVER"] = " ".PadRight(1 ); 
         dwReturn["KAASTUFE"] = " ".PadRight(1 ); 
         dwReturn["KAAPRTKZ"] = " ".PadRight(1 ); 
         dwReturn["KAASCHEMA"] = " ".PadRight(5 ); 
         dwReturn["KAASVZL"] = " ".PadRight(0 ); 
         dwReturn["KAAKZWECK"] = " ".PadRight(5 ); 
         dwReturn["KAAKZWVER"] = " ".PadRight(1 ); 
         dwReturn["KAAKZWVZL"] = " ".PadRight(0 ); 
         dwReturn["KAAFREZKZ"] = " ".PadRight(1 ); 
         dwReturn["KAADREZKZ"] = " ".PadRight(1 ); 
         dwReturn["KAABREZKZ"] = " ".PadRight(1 ); 
         dwReturn["KAAVWKZ"] = " ".PadRight(1 ); 
         dwReturn["KAAVWKANR"] = " ".PadRight(8 ); 
         dwReturn["KAAVWKAPOS"] = " ".PadRight(4 ); 
         dwReturn["KAAAKTKZ"] = " ".PadRight(1 ); 
         dwReturn["KAAKZSTD"] = " ".PadRight(1 ); 
         dwReturn["KAAAUFKRS"] = " ".PadRight(2 ); 
         dwReturn["KAAAUFLFD"] = " ".PadRight(6 ); 
         dwReturn["KAAAUFPOS"] = " ".PadRight(3 ); 
         dwReturn["KAAKAKUNDNR"] = " ".PadRight(8 ); 
         dwReturn["KAASCHBRT"] = " ".PadRight(0 ); 
         dwReturn["KAASCHLG"] = " ".PadRight(0 ); 
         dwReturn["KAAWRI"] = " ".PadRight(2 ); 
         dwReturn["KAALANDI"] = " ".PadRight(3 ); 
         dwReturn["KAAWRE"] = " ".PadRight(2 ); 
         dwReturn["KAALANDE"] = " ".PadRight(3 ); 
         dwReturn["KAAVERPZI"] = " ".PadRight(0 ); 
         dwReturn["KAAVERPZE"] = " ".PadRight(0 ); 
         dwReturn["KAAVERSZI"] = " ".PadRight(0 ); 
         dwReturn["KAAVERSZE"] = " ".PadRight(0 ); 
         dwReturn["KAAFRAZI"] = " ".PadRight(0 ); 
         dwReturn["KAAFRAZE"] = " ".PadRight(0 ); 
         dwReturn["KAAZOLLZI"] = " ".PadRight(0 ); 
         dwReturn["KAAZOLLZE"] = " ".PadRight(0 ); 
         dwReturn["KAAPROVZI"] = " ".PadRight(0 ); 
         dwReturn["KAAPROVZE"] = " ".PadRight(0 ); 
         dwReturn["KAABONZI"] = " ".PadRight(0 ); 
         dwReturn["KAABONZE"] = " ".PadRight(0 ); 
         dwReturn["KAASKTZI"] = " ".PadRight(0 ); 
         dwReturn["KAASKTZE"] = " ".PadRight(0 ); 
         dwReturn["KAAEVZI"] = " ".PadRight(0 ); 
         dwReturn["KAAEVZE"] = " ".PadRight(0 ); 
         dwReturn["KAASEKSZI"] = " ".PadRight(0 ); 
         dwReturn["KAASEKSZE"] = " ".PadRight(0 ); 
         dwReturn["KAASDBZI"] = " ".PadRight(0 ); 
         dwReturn["KAASDBZE"] = " ".PadRight(0 ); 
         dwReturn["KAAZINSZI"] = " ".PadRight(0 ); 
         dwReturn["KAAZINSZE"] = " ".PadRight(0 ); 
         dwReturn["KAAWAKZ"] = " ".PadRight(1 ); 
         dwReturn["KAAKUNDNR"] = " ".PadRight(8 ); 
         dwReturn["KAAWERK"] = " ".PadRight(3 ); 
         dwReturn["KAAABT"] = " ".PadRight(3 ); 
         dwReturn["KAAART"] = " ".PadRight(20 ); 
         dwReturn["KAAVAR"] = " ".PadRight(3 ); 
         dwReturn["KAAFARBG"] = " ".PadRight(1 ); 
         dwReturn["KAADESSG"] = " ".PadRight(1 ); 
         dwReturn["KAABESG"] = " ".PadRight(1 ); 
         dwReturn["KAAFARBE"] = " ".PadRight(10 ); 
         dwReturn["KAADESS"] = " ".PadRight(10 ); 
         dwReturn["KAACOL"] = " ".PadRight(10 ); 
         dwReturn["KAABESCHI"] = " ".PadRight(10 ); 
         dwReturn["KAAFARBS"] = " ".PadRight(10 ); 
         dwReturn["KAADESSS"] = " ".PadRight(10 ); 
         dwReturn["KAACOLS"] = " ".PadRight(10 ); 
         dwReturn["KAABESS"] = " ".PadRight(10 ); 
         dwReturn["KAAHK1"] = " ".PadRight(0 ); 
         dwReturn["KAAHK2"] = " ".PadRight(0 ); 
         dwReturn["KAAHK3"] = " ".PadRight(0 ); 
         dwReturn["KAAHK4"] = " ".PadRight(0 ); 
         dwReturn["KAAHK5"] = " ".PadRight(0 ); 
         dwReturn["KAAHK6"] = " ".PadRight(0 ); 
         dwReturn["KAAFE1"] = " ".PadRight(0 ); 
         dwReturn["KAAFE2"] = " ".PadRight(0 ); 
         dwReturn["KAAFE3"] = " ".PadRight(0 ); 
         dwReturn["KAAFE4"] = " ".PadRight(0 ); 
         dwReturn["KAAFE5"] = " ".PadRight(0 ); 
         dwReturn["KAAFE6"] = " ".PadRight(0 ); 
         dwReturn["KAAFE7"] = " ".PadRight(0 ); 
         dwReturn["KAAFE8"] = " ".PadRight(0 ); 
         dwReturn["KAAFE9"] = " ".PadRight(0 ); 
         dwReturn["KAAFE10"] = " ".PadRight(0 ); 
         dwReturn["KAAMKKG"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKKG1"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKKG2"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKKG3"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKKG4"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKKG5"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKKG6"] = " ".PadRight(0 ); 
         dwReturn["KAAMKSG"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKSG1"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKSG2"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKSG3"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKSG4"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKSG5"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKSG6"] = " ".PadRight(0 ); 
         dwReturn["KAAMKROHW"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKROHW1"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKROHW2"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKROHW3"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKROHW4"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKROHW5"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKROHW6"] = " ".PadRight(0 ); 
         dwReturn["KAAMKREZ"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKREZ1"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKREZ2"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKREZ3"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKREZ4"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKREZ5"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKREZ6"] = " ".PadRight(0 ); 
         dwReturn["KAAMKZU"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKZU1"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKZU2"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKZU3"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKZU4"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKZU5"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKZU6"] = " ".PadRight(0 ); 
         dwReturn["KAAMKSO"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKSO1"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKSO2"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKSO3"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKSO4"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKSO5"] = " ".PadRight(0 ); 
         dwReturn["KAAMGKSO6"] = " ".PadRight(0 ); 
         dwReturn["KAAFFKG"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKG1"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKG2"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKG3"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKG4"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKG5"] = " ".PadRight(0 ); 
         dwReturn["KAASEKG"] = " ".PadRight(0 ); 
         dwReturn["KAAFFKK"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKK1"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKK2"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKK3"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKK4"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKK5"] = " ".PadRight(0 ); 
         dwReturn["KAASEKK"] = " ".PadRight(0 ); 
         dwReturn["KAAFFKROHW"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKROHW1"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKROHW2"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKROHW3"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKROHW4"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKROHW5"] = " ".PadRight(0 ); 
         dwReturn["KAASEKROHW"] = " ".PadRight(0 ); 
         dwReturn["KAAFFKV"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKV1"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKV2"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKV3"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKV4"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKV5"] = " ".PadRight(0 ); 
         dwReturn["KAASEKV"] = " ".PadRight(0 ); 
         dwReturn["KAAFFKKONF"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKKONF1"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKKONF2"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKKONF3"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKKONF4"] = " ".PadRight(0 ); 
         dwReturn["KAAFEKKONF5"] = " ".PadRight(0 ); 
         dwReturn["KAASEKKONF"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKTOT1"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGK1"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGK2"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGK3"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGK4"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGK5"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKTOT2"] = " ".PadRight(0 ); 
         dwReturn["KAALAEV"] = " ".PadRight(0 ); 
         dwReturn["KAALAETOT1"] = " ".PadRight(0 ); 
         dwReturn["KAALAETOT2"] = " ".PadRight(0 ); 
         dwReturn["KAALAETOT3"] = " ".PadRight(0 ); 
         dwReturn["KAALAETOT4"] = " ".PadRight(0 ); 
         dwReturn["KAALAETOT5"] = " ".PadRight(0 ); 
         dwReturn["KAALAEG"] = " ".PadRight(0 ); 
         dwReturn["KAAWAGV"] = " ".PadRight(0 ); 
         dwReturn["KAAWAGTOT1"] = " ".PadRight(0 ); 
         dwReturn["KAAWAGTOT2"] = " ".PadRight(0 ); 
         dwReturn["KAAWAGTOT3"] = " ".PadRight(0 ); 
         dwReturn["KAAWAGTOT4"] = " ".PadRight(0 ); 
         dwReturn["KAAWAGTOT5"] = " ".PadRight(0 ); 
         dwReturn["KAAWAGG"] = " ".PadRight(0 ); 
         dwReturn["KAAMEZV"] = " ".PadRight(0 ); 
         dwReturn["KAAMEZTOT1"] = " ".PadRight(0 ); 
         dwReturn["KAAMEZTOT2"] = " ".PadRight(0 ); 
         dwReturn["KAAMEZTOT3"] = " ".PadRight(0 ); 
         dwReturn["KAAMEZTOT4"] = " ".PadRight(0 ); 
         dwReturn["KAAMEZTOT5"] = " ".PadRight(0 ); 
         dwReturn["KAAMEZG"] = " ".PadRight(0 ); 
         dwReturn["KAARESERVE1"] = " ".PadRight(0 ); 
         dwReturn["KAARESERVE21"] = " ".PadRight(0 ); 
         dwReturn["KAARESERVE22"] = " ".PadRight(0 ); 
         dwReturn["KAARESERVE23"] = " ".PadRight(0 ); 
         dwReturn["KAARESERVE24"] = " ".PadRight(0 ); 
         dwReturn["KAARESERVE25"] = " ".PadRight(0 ); 
         dwReturn["KAARESERVE3"] = " ".PadRight(0 ); 
         dwReturn["KAAKOGRP1"] = " ".PadRight(4 ); 
         dwReturn["KAAVVGKBTR1"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT11"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT12"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT13"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT14"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT15"] = " ".PadRight(0 ); 
         dwReturn["KAAKOGRP2"] = " ".PadRight(4 ); 
         dwReturn["KAAVVGKBTR2"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT21"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT22"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT23"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT24"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT25"] = " ".PadRight(0 ); 
         dwReturn["KAAKOGRP3"] = " ".PadRight(4 ); 
         dwReturn["KAAVVGKBTR3"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT31"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT32"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT33"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT34"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT35"] = " ".PadRight(0 ); 
         dwReturn["KAAKOGRP4"] = " ".PadRight(4 ); 
         dwReturn["KAAVVGKBTR4"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT41"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT42"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT43"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT44"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT45"] = " ".PadRight(0 ); 
         dwReturn["KAAKOGRP5"] = " ".PadRight(4 ); 
         dwReturn["KAAVVGKBTR5"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT51"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT52"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT53"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT54"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT55"] = " ".PadRight(0 ); 
         dwReturn["KAAKOGRP6"] = " ".PadRight(4 ); 
         dwReturn["KAAVVGKBTR6"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT61"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT62"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT63"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT64"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT65"] = " ".PadRight(0 ); 
         dwReturn["KAAKOGRP7"] = " ".PadRight(4 ); 
         dwReturn["KAAVVGKBTR7"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT71"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT72"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT73"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT74"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT75"] = " ".PadRight(0 ); 
         dwReturn["KAAKOGRP8"] = " ".PadRight(4 ); 
         dwReturn["KAAVVGKBTR8"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT81"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT82"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT83"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT84"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT85"] = " ".PadRight(0 ); 
         dwReturn["KAAKOGRP9"] = " ".PadRight(4 ); 
         dwReturn["KAAVVGKBTR9"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT91"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT92"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT93"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT94"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT95"] = " ".PadRight(0 ); 
         dwReturn["KAAKOGRP10"] = " ".PadRight(4 ); 
         dwReturn["KAAVVGKBTR10"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT101"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT102"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT103"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT104"] = " ".PadRight(0 ); 
         dwReturn["KAAVVGKAUFT105"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKG1"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKG2"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKG3"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKG4"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKG5"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKK1"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKK2"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKK3"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKK4"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKK5"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKROHW1"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKROHW2"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKROHW3"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKROHW4"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKROHW5"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKV1"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKV2"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKV3"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKV4"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKV5"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKKONF1"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKKONF2"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKKONF3"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKKONF4"] = " ".PadRight(0 ); 
         dwReturn["KAAFGKKONF5"] = " ".PadRight(0 ); 
         dwReturn["KAAVERPI"] = " ".PadRight(0 ); 
         dwReturn["KAAVERPE"] = " ".PadRight(0 ); 
         dwReturn["KAAVERSI"] = " ".PadRight(0 ); 
         dwReturn["KAAVERSE"] = " ".PadRight(0 ); 
         dwReturn["KAAFRAI"] = " ".PadRight(0 ); 
         dwReturn["KAAFRAE"] = " ".PadRight(0 ); 
         dwReturn["KAAZOLLI"] = " ".PadRight(0 ); 
         dwReturn["KAAZOLLE"] = " ".PadRight(0 ); 
         dwReturn["KAAPROVI"] = " ".PadRight(0 ); 
         dwReturn["KAAPROVE"] = " ".PadRight(0 ); 
         dwReturn["KAABONI"] = " ".PadRight(0 ); 
         dwReturn["KAABONE"] = " ".PadRight(0 ); 
         dwReturn["KAASKTI"] = " ".PadRight(0 ); 
         dwReturn["KAASKTE"] = " ".PadRight(0 ); 
         dwReturn["KAAEVI"] = " ".PadRight(0 ); 
         dwReturn["KAAEVE"] = " ".PadRight(0 ); 
         dwReturn["KAASEKSI"] = " ".PadRight(0 ); 
         dwReturn["KAASEKSE"] = " ".PadRight(0 ); 
         dwReturn["KAASDBI"] = " ".PadRight(0 ); 
         dwReturn["KAASDBE"] = " ".PadRight(0 ); 
         dwReturn["KAAZINSI"] = " ".PadRight(0 ); 
         dwReturn["KAAZINSE"] = " ".PadRight(0 ); 
         dwReturn["KAASCHK"] = " ".PadRight(0 ); 
         dwReturn["KAAVERPR"] = " ".PadRight(0 ); 
         dwReturn["KAAZUSCHL"] = " ".PadRight(0 ); 
         dwReturn["KAAVERKPR"] = " ".PadRight(0 ); 
         dwReturn["KAAWBBRT"] = " ".PadRight(0 ); 
         dwReturn["KAAWBF"] = " ".PadRight(0 ); 
         dwReturn["KAABIND"] = " ".PadRight(15 ); 
         dwReturn["KAARWBRT"] = " ".PadRight(0 ); 
         dwReturn["KAARGRLFD"] = " ".PadRight(0 ); 
         dwReturn["KAASCHT"] = " ".PadRight(0 ); 
         dwReturn["KAAFWBRT"] = " ".PadRight(0 ); 
         dwReturn["KAAFGRLFD"] = " ".PadRight(0 ); 
         dwReturn["KAALAEAEND"] = " ".PadRight(0 ); 
         dwReturn["KAAMEZ"] = " ".PadRight(0 ); 
         dwReturn["KAAWAG"] = " ".PadRight(0 ); 
         dwReturn["KAAFDDIK"] = " ".PadRight(0 ); 
         dwReturn["KAAFDISM"] = " ".PadRight(0 ); 
         dwReturn["KAAFDDIS"] = " ".PadRight(0 ); 
         dwReturn["KAAFDDIM"] = " ".PadRight(3 ); 
         dwReturn["KAAFDDIF"] = " ".PadRight(0 ); 
         dwReturn["KAAFDLGS"] = " ".PadRight(0 ); 
         dwReturn["KAAMFS"] = " ".PadRight(1 ); 
         dwReturn["KAARSTANT1"] = " ".PadRight(0 ); 
         dwReturn["KAARSTBEZ1"] = " ".PadRight(6 ); 
         dwReturn["KAARSTANT2"] = " ".PadRight(0 ); 
         dwReturn["KAARSTBEZ2"] = " ".PadRight(6 ); 
         dwReturn["KAARSTANT3"] = " ".PadRight(0 ); 
         dwReturn["KAARSTBEZ3"] = " ".PadRight(6 ); 
         dwReturn["KAARSTANT4"] = " ".PadRight(0 ); 
         dwReturn["KAARSTBEZ4"] = " ".PadRight(6 ); 
         dwReturn["KAAVB"] = " ".PadRight(3 ); 
         dwReturn["KAAPROGRP"] = " ".PadRight(3 ); 
         dwReturn["KAAARTGRP"] = " ".PadRight(3 ); 
         dwReturn["KAAKALKART"] = " ".PadRight(20 ); 
         dwReturn["KAAKALKVAR"] = " ".PadRight(3 ); 
         dwReturn["KAABRTFAKTOR"] = " ".PadRight(8 ); 
         dwReturn["KAASTUEART"] = " ".PadRight(3 ); 
         dwReturn["KAABAHNIG"] = " ".PadRight(1 ); 
         dwReturn["KAAZUKAUF"] = " ".PadRight(1 ); 
         dwReturn["KAAAPSPERRE"] = " ".PadRight(1 ); 
         dwReturn["KAAAPSPERRE2"] = " ".PadRight(1 ); 
         dwReturn["KAAAPSPERRE3"] = " ".PadRight(1 ); 
         dwReturn["KAADART"] = " ".PadRight(20 ); 
         dwReturn["KAADVAR"] = " ".PadRight(3 ); 
         dwReturn["KAAZUSTAND"] = " ".PadRight(4 ); 
         dwReturn["KAAAUFM"] = " ".PadRight(2 ); 
         dwReturn["KAAVERP"] = " ".PadRight(3 ); 
         dwReturn["KAAZAM"] = " ".PadRight(2 ); 
         dwReturn["KAAURRENDEM"] = " ".PadRight(0 ); 
         dwReturn["KAAURRENDEM2"] = " ".PadRight(0 ); 
         dwReturn["KAAGSPH"] = " ".PadRight(0 ); 
         dwReturn["KAAMMIN"] = " ".PadRight(0 ); 
         dwReturn["KAAFILLER"] = " ".PadRight(162 ); 
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapKAAUF(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveKAAUF(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryKAAUF(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapKAAUF(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertKAAUF(dwLocal, ITXDBVERSION);
            }
            UpdateKAAUF(dwLocal);
        }
        public void InsertKAAUF(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO KAAUF(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryKAAUF(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM KAAUF WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM KAAUF  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "KAAUF";
            Return = Result;
            return Return;
        }
        public void DeleteKAAUF(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM KAAUF   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdateKAAUF(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE KAAUF SET "
                    +"KAAMANDANT= :KAAMANDANT,"
                    +"KAAKANR= :KAAKANR,"
                    +"KAAKAPOS= :KAAKAPOS,"
                    +"KAAAENZL= :KAAAENZL,"
                    +"KAAAENB= :KAAAENB,"
                    +"KAAAEND= :KAAAEND,"
                    +"KAANEUB= :KAANEUB,"
                    +"KAANEUD= :KAANEUD,"
                    +"KAAKZENTW= :KAAKZENTW,"
                    +"KAASTATUS= :KAASTATUS,"
                    +"KAAVERFA= :KAAVERFA,"
                    +"KAAPSEUDO= :KAAPSEUDO,"
                    +"KAAURKANR= :KAAURKANR,"
                    +"KAAURKAPOS= :KAAURKAPOS,"
                    +"KAAZWECK= :KAAZWECK,"
                    +"KAAVER= :KAAVER,"
                    +"KAASTUFE= :KAASTUFE,"
                    +"KAAPRTKZ= :KAAPRTKZ,"
                    +"KAASCHEMA= :KAASCHEMA,"
                    +"KAASVZL= :KAASVZL,"
                    +"KAAKZWECK= :KAAKZWECK,"
                    +"KAAKZWVER= :KAAKZWVER,"
                    +"KAAKZWVZL= :KAAKZWVZL,"
                    +"KAAFREZKZ= :KAAFREZKZ,"
                    +"KAADREZKZ= :KAADREZKZ,"
                    +"KAABREZKZ= :KAABREZKZ,"
                    +"KAAVWKZ= :KAAVWKZ,"
                    +"KAAVWKANR= :KAAVWKANR,"
                    +"KAAVWKAPOS= :KAAVWKAPOS,"
                    +"KAAAKTKZ= :KAAAKTKZ,"
                    +"KAAKZSTD= :KAAKZSTD,"
                    +"KAAAUFKRS= :KAAAUFKRS,"
                    +"KAAAUFLFD= :KAAAUFLFD,"
                    +"KAAAUFPOS= :KAAAUFPOS,"
                    +"KAAKAKUNDNR= :KAAKAKUNDNR,"
                    +"KAASCHBRT= :KAASCHBRT,"
                    +"KAASCHLG= :KAASCHLG,"
                    +"KAAWRI= :KAAWRI,"
                    +"KAALANDI= :KAALANDI,"
                    +"KAAWRE= :KAAWRE,"
                    +"KAALANDE= :KAALANDE,"
                    +"KAAVERPZI= :KAAVERPZI,"
                    +"KAAVERPZE= :KAAVERPZE,"
                    +"KAAVERSZI= :KAAVERSZI,"
                    +"KAAVERSZE= :KAAVERSZE,"
                    +"KAAFRAZI= :KAAFRAZI,"
                    +"KAAFRAZE= :KAAFRAZE,"
                    +"KAAZOLLZI= :KAAZOLLZI,"
                    +"KAAZOLLZE= :KAAZOLLZE,"
                    +"KAAPROVZI= :KAAPROVZI,"
                    +"KAAPROVZE= :KAAPROVZE,"
                    +"KAABONZI= :KAABONZI,"
                    +"KAABONZE= :KAABONZE,"
                    +"KAASKTZI= :KAASKTZI,"
                    +"KAASKTZE= :KAASKTZE,"
                    +"KAAEVZI= :KAAEVZI,"
                    +"KAAEVZE= :KAAEVZE,"
                    +"KAASEKSZI= :KAASEKSZI,"
                    +"KAASEKSZE= :KAASEKSZE,"
                    +"KAASDBZI= :KAASDBZI,"
                    +"KAASDBZE= :KAASDBZE,"
                    +"KAAZINSZI= :KAAZINSZI,"
                    +"KAAZINSZE= :KAAZINSZE,"
                    +"KAAWAKZ= :KAAWAKZ,"
                    +"KAAKUNDNR= :KAAKUNDNR,"
                    +"KAAWERK= :KAAWERK,"
                    +"KAAABT= :KAAABT,"
                    +"KAAART= :KAAART,"
                    +"KAAVAR= :KAAVAR,"
                    +"KAAFARBG= :KAAFARBG,"
                    +"KAADESSG= :KAADESSG,"
                    +"KAABESG= :KAABESG,"
                    +"KAAFARBE= :KAAFARBE,"
                    +"KAADESS= :KAADESS,"
                    +"KAACOL= :KAACOL,"
                    +"KAABESCHI= :KAABESCHI,"
                    +"KAAFARBS= :KAAFARBS,"
                    +"KAADESSS= :KAADESSS,"
                    +"KAACOLS= :KAACOLS,"
                    +"KAABESS= :KAABESS,"
                    +"KAAHK1= :KAAHK1,"
                    +"KAAHK2= :KAAHK2,"
                    +"KAAHK3= :KAAHK3,"
                    +"KAAHK4= :KAAHK4,"
                    +"KAAHK5= :KAAHK5,"
                    +"KAAHK6= :KAAHK6,"
                    +"KAAFE1= :KAAFE1,"
                    +"KAAFE2= :KAAFE2,"
                    +"KAAFE3= :KAAFE3,"
                    +"KAAFE4= :KAAFE4,"
                    +"KAAFE5= :KAAFE5,"
                    +"KAAFE6= :KAAFE6,"
                    +"KAAFE7= :KAAFE7,"
                    +"KAAFE8= :KAAFE8,"
                    +"KAAFE9= :KAAFE9,"
                    +"KAAFE10= :KAAFE10,"
                    +"KAAMKKG= :KAAMKKG,"
                    +"KAAMGKKG1= :KAAMGKKG1,"
                    +"KAAMGKKG2= :KAAMGKKG2,"
                    +"KAAMGKKG3= :KAAMGKKG3,"
                    +"KAAMGKKG4= :KAAMGKKG4,"
                    +"KAAMGKKG5= :KAAMGKKG5,"
                    +"KAAMGKKG6= :KAAMGKKG6,"
                    +"KAAMKSG= :KAAMKSG,"
                    +"KAAMGKSG1= :KAAMGKSG1,"
                    +"KAAMGKSG2= :KAAMGKSG2,"
                    +"KAAMGKSG3= :KAAMGKSG3,"
                    +"KAAMGKSG4= :KAAMGKSG4,"
                    +"KAAMGKSG5= :KAAMGKSG5,"
                    +"KAAMGKSG6= :KAAMGKSG6,"
                    +"KAAMKROHW= :KAAMKROHW,"
                    +"KAAMGKROHW1= :KAAMGKROHW1,"
                    +"KAAMGKROHW2= :KAAMGKROHW2,"
                    +"KAAMGKROHW3= :KAAMGKROHW3,"
                    +"KAAMGKROHW4= :KAAMGKROHW4,"
                    +"KAAMGKROHW5= :KAAMGKROHW5,"
                    +"KAAMGKROHW6= :KAAMGKROHW6,"
                    +"KAAMKREZ= :KAAMKREZ,"
                    +"KAAMGKREZ1= :KAAMGKREZ1,"
                    +"KAAMGKREZ2= :KAAMGKREZ2,"
                    +"KAAMGKREZ3= :KAAMGKREZ3,"
                    +"KAAMGKREZ4= :KAAMGKREZ4,"
                    +"KAAMGKREZ5= :KAAMGKREZ5,"
                    +"KAAMGKREZ6= :KAAMGKREZ6,"
                    +"KAAMKZU= :KAAMKZU,"
                    +"KAAMGKZU1= :KAAMGKZU1,"
                    +"KAAMGKZU2= :KAAMGKZU2,"
                    +"KAAMGKZU3= :KAAMGKZU3,"
                    +"KAAMGKZU4= :KAAMGKZU4,"
                    +"KAAMGKZU5= :KAAMGKZU5,"
                    +"KAAMGKZU6= :KAAMGKZU6,"
                    +"KAAMKSO= :KAAMKSO,"
                    +"KAAMGKSO1= :KAAMGKSO1,"
                    +"KAAMGKSO2= :KAAMGKSO2,"
                    +"KAAMGKSO3= :KAAMGKSO3,"
                    +"KAAMGKSO4= :KAAMGKSO4,"
                    +"KAAMGKSO5= :KAAMGKSO5,"
                    +"KAAMGKSO6= :KAAMGKSO6,"
                    +"KAAFFKG= :KAAFFKG,"
                    +"KAAFEKG1= :KAAFEKG1,"
                    +"KAAFEKG2= :KAAFEKG2,"
                    +"KAAFEKG3= :KAAFEKG3,"
                    +"KAAFEKG4= :KAAFEKG4,"
                    +"KAAFEKG5= :KAAFEKG5,"
                    +"KAASEKG= :KAASEKG,"
                    +"KAAFFKK= :KAAFFKK,"
                    +"KAAFEKK1= :KAAFEKK1,"
                    +"KAAFEKK2= :KAAFEKK2,"
                    +"KAAFEKK3= :KAAFEKK3,"
                    +"KAAFEKK4= :KAAFEKK4,"
                    +"KAAFEKK5= :KAAFEKK5,"
                    +"KAASEKK= :KAASEKK,"
                    +"KAAFFKROHW= :KAAFFKROHW,"
                    +"KAAFEKROHW1= :KAAFEKROHW1,"
                    +"KAAFEKROHW2= :KAAFEKROHW2,"
                    +"KAAFEKROHW3= :KAAFEKROHW3,"
                    +"KAAFEKROHW4= :KAAFEKROHW4,"
                    +"KAAFEKROHW5= :KAAFEKROHW5,"
                    +"KAASEKROHW= :KAASEKROHW,"
                    +"KAAFFKV= :KAAFFKV,"
                    +"KAAFEKV1= :KAAFEKV1,"
                    +"KAAFEKV2= :KAAFEKV2,"
                    +"KAAFEKV3= :KAAFEKV3,"
                    +"KAAFEKV4= :KAAFEKV4,"
                    +"KAAFEKV5= :KAAFEKV5,"
                    +"KAASEKV= :KAASEKV,"
                    +"KAAFFKKONF= :KAAFFKKONF,"
                    +"KAAFEKKONF1= :KAAFEKKONF1,"
                    +"KAAFEKKONF2= :KAAFEKKONF2,"
                    +"KAAFEKKONF3= :KAAFEKKONF3,"
                    +"KAAFEKKONF4= :KAAFEKKONF4,"
                    +"KAAFEKKONF5= :KAAFEKKONF5,"
                    +"KAASEKKONF= :KAASEKKONF,"
                    +"KAAVVGKTOT1= :KAAVVGKTOT1,"
                    +"KAAVVGK1= :KAAVVGK1,"
                    +"KAAVVGK2= :KAAVVGK2,"
                    +"KAAVVGK3= :KAAVVGK3,"
                    +"KAAVVGK4= :KAAVVGK4,"
                    +"KAAVVGK5= :KAAVVGK5,"
                    +"KAAVVGKTOT2= :KAAVVGKTOT2,"
                    +"KAALAEV= :KAALAEV,"
                    +"KAALAETOT1= :KAALAETOT1,"
                    +"KAALAETOT2= :KAALAETOT2,"
                    +"KAALAETOT3= :KAALAETOT3,"
                    +"KAALAETOT4= :KAALAETOT4,"
                    +"KAALAETOT5= :KAALAETOT5,"
                    +"KAALAEG= :KAALAEG,"
                    +"KAAWAGV= :KAAWAGV,"
                    +"KAAWAGTOT1= :KAAWAGTOT1,"
                    +"KAAWAGTOT2= :KAAWAGTOT2,"
                    +"KAAWAGTOT3= :KAAWAGTOT3,"
                    +"KAAWAGTOT4= :KAAWAGTOT4,"
                    +"KAAWAGTOT5= :KAAWAGTOT5,"
                    +"KAAWAGG= :KAAWAGG,"
                    +"KAAMEZV= :KAAMEZV,"
                    +"KAAMEZTOT1= :KAAMEZTOT1,"
                    +"KAAMEZTOT2= :KAAMEZTOT2,"
                    +"KAAMEZTOT3= :KAAMEZTOT3,"
                    +"KAAMEZTOT4= :KAAMEZTOT4,"
                    +"KAAMEZTOT5= :KAAMEZTOT5,"
                    +"KAAMEZG= :KAAMEZG,"
                    +"KAARESERVE1= :KAARESERVE1,"
                    +"KAARESERVE21= :KAARESERVE21,"
                    +"KAARESERVE22= :KAARESERVE22,"
                    +"KAARESERVE23= :KAARESERVE23,"
                    +"KAARESERVE24= :KAARESERVE24,"
                    +"KAARESERVE25= :KAARESERVE25,"
                    +"KAARESERVE3= :KAARESERVE3,"
                    +"KAAKOGRP1= :KAAKOGRP1,"
                    +"KAAVVGKBTR1= :KAAVVGKBTR1,"
                    +"KAAVVGKAUFT11= :KAAVVGKAUFT11,"
                    +"KAAVVGKAUFT12= :KAAVVGKAUFT12,"
                    +"KAAVVGKAUFT13= :KAAVVGKAUFT13,"
                    +"KAAVVGKAUFT14= :KAAVVGKAUFT14,"
                    +"KAAVVGKAUFT15= :KAAVVGKAUFT15,"
                    +"KAAKOGRP2= :KAAKOGRP2,"
                    +"KAAVVGKBTR2= :KAAVVGKBTR2,"
                    +"KAAVVGKAUFT21= :KAAVVGKAUFT21,"
                    +"KAAVVGKAUFT22= :KAAVVGKAUFT22,"
                    +"KAAVVGKAUFT23= :KAAVVGKAUFT23,"
                    +"KAAVVGKAUFT24= :KAAVVGKAUFT24,"
                    +"KAAVVGKAUFT25= :KAAVVGKAUFT25,"
                    +"KAAKOGRP3= :KAAKOGRP3,"
                    +"KAAVVGKBTR3= :KAAVVGKBTR3,"
                    +"KAAVVGKAUFT31= :KAAVVGKAUFT31,"
                    +"KAAVVGKAUFT32= :KAAVVGKAUFT32,"
                    +"KAAVVGKAUFT33= :KAAVVGKAUFT33,"
                    +"KAAVVGKAUFT34= :KAAVVGKAUFT34,"
                    +"KAAVVGKAUFT35= :KAAVVGKAUFT35,"
                    +"KAAKOGRP4= :KAAKOGRP4,"
                    +"KAAVVGKBTR4= :KAAVVGKBTR4,"
                    +"KAAVVGKAUFT41= :KAAVVGKAUFT41,"
                    +"KAAVVGKAUFT42= :KAAVVGKAUFT42,"
                    +"KAAVVGKAUFT43= :KAAVVGKAUFT43,"
                    +"KAAVVGKAUFT44= :KAAVVGKAUFT44,"
                    +"KAAVVGKAUFT45= :KAAVVGKAUFT45,"
                    +"KAAKOGRP5= :KAAKOGRP5,"
                    +"KAAVVGKBTR5= :KAAVVGKBTR5,"
                    +"KAAVVGKAUFT51= :KAAVVGKAUFT51,"
                    +"KAAVVGKAUFT52= :KAAVVGKAUFT52,"
                    +"KAAVVGKAUFT53= :KAAVVGKAUFT53,"
                    +"KAAVVGKAUFT54= :KAAVVGKAUFT54,"
                    +"KAAVVGKAUFT55= :KAAVVGKAUFT55,"
                    +"KAAKOGRP6= :KAAKOGRP6,"
                    +"KAAVVGKBTR6= :KAAVVGKBTR6,"
                    +"KAAVVGKAUFT61= :KAAVVGKAUFT61,"
                    +"KAAVVGKAUFT62= :KAAVVGKAUFT62,"
                    +"KAAVVGKAUFT63= :KAAVVGKAUFT63,"
                    +"KAAVVGKAUFT64= :KAAVVGKAUFT64,"
                    +"KAAVVGKAUFT65= :KAAVVGKAUFT65,"
                    +"KAAKOGRP7= :KAAKOGRP7,"
                    +"KAAVVGKBTR7= :KAAVVGKBTR7,"
                    +"KAAVVGKAUFT71= :KAAVVGKAUFT71,"
                    +"KAAVVGKAUFT72= :KAAVVGKAUFT72,"
                    +"KAAVVGKAUFT73= :KAAVVGKAUFT73,"
                    +"KAAVVGKAUFT74= :KAAVVGKAUFT74,"
                    +"KAAVVGKAUFT75= :KAAVVGKAUFT75,"
                    +"KAAKOGRP8= :KAAKOGRP8,"
                    +"KAAVVGKBTR8= :KAAVVGKBTR8,"
                    +"KAAVVGKAUFT81= :KAAVVGKAUFT81,"
                    +"KAAVVGKAUFT82= :KAAVVGKAUFT82,"
                    +"KAAVVGKAUFT83= :KAAVVGKAUFT83,"
                    +"KAAVVGKAUFT84= :KAAVVGKAUFT84,"
                    +"KAAVVGKAUFT85= :KAAVVGKAUFT85,"
                    +"KAAKOGRP9= :KAAKOGRP9,"
                    +"KAAVVGKBTR9= :KAAVVGKBTR9,"
                    +"KAAVVGKAUFT91= :KAAVVGKAUFT91,"
                    +"KAAVVGKAUFT92= :KAAVVGKAUFT92,"
                    +"KAAVVGKAUFT93= :KAAVVGKAUFT93,"
                    +"KAAVVGKAUFT94= :KAAVVGKAUFT94,"
                    +"KAAVVGKAUFT95= :KAAVVGKAUFT95,"
                    +"KAAKOGRP10= :KAAKOGRP10,"
                    +"KAAVVGKBTR10= :KAAVVGKBTR10,"
                    +"KAAVVGKAUFT101= :KAAVVGKAUFT101,"
                    +"KAAVVGKAUFT102= :KAAVVGKAUFT102,"
                    +"KAAVVGKAUFT103= :KAAVVGKAUFT103,"
                    +"KAAVVGKAUFT104= :KAAVVGKAUFT104,"
                    +"KAAVVGKAUFT105= :KAAVVGKAUFT105,"
                    +"KAAFGKG1= :KAAFGKG1,"
                    +"KAAFGKG2= :KAAFGKG2,"
                    +"KAAFGKG3= :KAAFGKG3,"
                    +"KAAFGKG4= :KAAFGKG4,"
                    +"KAAFGKG5= :KAAFGKG5,"
                    +"KAAFGKK1= :KAAFGKK1,"
                    +"KAAFGKK2= :KAAFGKK2,"
                    +"KAAFGKK3= :KAAFGKK3,"
                    +"KAAFGKK4= :KAAFGKK4,"
                    +"KAAFGKK5= :KAAFGKK5,"
                    +"KAAFGKROHW1= :KAAFGKROHW1,"
                    +"KAAFGKROHW2= :KAAFGKROHW2,"
                    +"KAAFGKROHW3= :KAAFGKROHW3,"
                    +"KAAFGKROHW4= :KAAFGKROHW4,"
                    +"KAAFGKROHW5= :KAAFGKROHW5,"
                    +"KAAFGKV1= :KAAFGKV1,"
                    +"KAAFGKV2= :KAAFGKV2,"
                    +"KAAFGKV3= :KAAFGKV3,"
                    +"KAAFGKV4= :KAAFGKV4,"
                    +"KAAFGKV5= :KAAFGKV5,"
                    +"KAAFGKKONF1= :KAAFGKKONF1,"
                    +"KAAFGKKONF2= :KAAFGKKONF2,"
                    +"KAAFGKKONF3= :KAAFGKKONF3,"
                    +"KAAFGKKONF4= :KAAFGKKONF4,"
                    +"KAAFGKKONF5= :KAAFGKKONF5,"
                    +"KAAVERPI= :KAAVERPI,"
                    +"KAAVERPE= :KAAVERPE,"
                    +"KAAVERSI= :KAAVERSI,"
                    +"KAAVERSE= :KAAVERSE,"
                    +"KAAFRAI= :KAAFRAI,"
                    +"KAAFRAE= :KAAFRAE,"
                    +"KAAZOLLI= :KAAZOLLI,"
                    +"KAAZOLLE= :KAAZOLLE,"
                    +"KAAPROVI= :KAAPROVI,"
                    +"KAAPROVE= :KAAPROVE,"
                    +"KAABONI= :KAABONI,"
                    +"KAABONE= :KAABONE,"
                    +"KAASKTI= :KAASKTI,"
                    +"KAASKTE= :KAASKTE,"
                    +"KAAEVI= :KAAEVI,"
                    +"KAAEVE= :KAAEVE,"
                    +"KAASEKSI= :KAASEKSI,"
                    +"KAASEKSE= :KAASEKSE,"
                    +"KAASDBI= :KAASDBI,"
                    +"KAASDBE= :KAASDBE,"
                    +"KAAZINSI= :KAAZINSI,"
                    +"KAAZINSE= :KAAZINSE,"
                    +"KAASCHK= :KAASCHK,"
                    +"KAAVERPR= :KAAVERPR,"
                    +"KAAZUSCHL= :KAAZUSCHL,"
                    +"KAAVERKPR= :KAAVERKPR,"
                    +"KAAWBBRT= :KAAWBBRT,"
                    +"KAAWBF= :KAAWBF,"
                    +"KAABIND= :KAABIND,"
                    +"KAARWBRT= :KAARWBRT,"
                    +"KAARGRLFD= :KAARGRLFD,"
                    +"KAASCHT= :KAASCHT,"
                    +"KAAFWBRT= :KAAFWBRT,"
                    +"KAAFGRLFD= :KAAFGRLFD,"
                    +"KAALAEAEND= :KAALAEAEND,"
                    +"KAAMEZ= :KAAMEZ,"
                    +"KAAWAG= :KAAWAG,"
                    +"KAAFDDIK= :KAAFDDIK,"
                    +"KAAFDISM= :KAAFDISM,"
                    +"KAAFDDIS= :KAAFDDIS,"
                    +"KAAFDDIM= :KAAFDDIM,"
                    +"KAAFDDIF= :KAAFDDIF,"
                    +"KAAFDLGS= :KAAFDLGS,"
                    +"KAAMFS= :KAAMFS,"
                    +"KAARSTANT1= :KAARSTANT1,"
                    +"KAARSTBEZ1= :KAARSTBEZ1,"
                    +"KAARSTANT2= :KAARSTANT2,"
                    +"KAARSTBEZ2= :KAARSTBEZ2,"
                    +"KAARSTANT3= :KAARSTANT3,"
                    +"KAARSTBEZ3= :KAARSTBEZ3,"
                    +"KAARSTANT4= :KAARSTANT4,"
                    +"KAARSTBEZ4= :KAARSTBEZ4,"
                    +"KAAVB= :KAAVB,"
                    +"KAAPROGRP= :KAAPROGRP,"
                    +"KAAARTGRP= :KAAARTGRP,"
                    +"KAAKALKART= :KAAKALKART,"
                    +"KAAKALKVAR= :KAAKALKVAR,"
                    +"KAABRTFAKTOR= :KAABRTFAKTOR,"
                    +"KAASTUEART= :KAASTUEART,"
                    +"KAABAHNIG= :KAABAHNIG,"
                    +"KAAZUKAUF= :KAAZUKAUF,"
                    +"KAAAPSPERRE= :KAAAPSPERRE,"
                    +"KAAAPSPERRE2= :KAAAPSPERRE2,"
                    +"KAAAPSPERRE3= :KAAAPSPERRE3,"
                    +"KAADART= :KAADART,"
                    +"KAADVAR= :KAADVAR,"
                    +"KAAZUSTAND= :KAAZUSTAND,"
                    +"KAAAUFM= :KAAAUFM,"
                    +"KAAVERP= :KAAVERP,"
                    +"KAAZAM= :KAAZAM,"
                    +"KAAURRENDEM= :KAAURRENDEM,"
                    +"KAAURRENDEM2= :KAAURRENDEM2,"
                    +"KAAGSPH= :KAAGSPH,"
                    +"KAAMMIN= :KAAMMIN,"
                    +"KAAFILLER= :KAAFILLER,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("KAAMANDANT", OracleType.NVarChar).Value = dwData["KAAMANDANT"].ToString(); 
          or1.Parameters.Add("KAAKANR", OracleType.NVarChar).Value = dwData["KAAKANR"].ToString(); 
          or1.Parameters.Add("KAAKAPOS", OracleType.NVarChar).Value = dwData["KAAKAPOS"].ToString(); 
          or1.Parameters.Add("KAAAENZL", OracleType.NVarChar).Value = dwData["KAAAENZL"].ToString(); 
          or1.Parameters.Add("KAAAENB", OracleType.NVarChar).Value = dwData["KAAAENB"].ToString(); 
          or1.Parameters.Add("KAAAEND", OracleType.NVarChar).Value = dwData["KAAAEND"].ToString(); 
          or1.Parameters.Add("KAANEUB", OracleType.NVarChar).Value = dwData["KAANEUB"].ToString(); 
          or1.Parameters.Add("KAANEUD", OracleType.NVarChar).Value = dwData["KAANEUD"].ToString(); 
          or1.Parameters.Add("KAAKZENTW", OracleType.NVarChar).Value = dwData["KAAKZENTW"].ToString(); 
          or1.Parameters.Add("KAASTATUS", OracleType.NVarChar).Value = dwData["KAASTATUS"].ToString(); 
          or1.Parameters.Add("KAAVERFA", OracleType.NVarChar).Value = dwData["KAAVERFA"].ToString(); 
          or1.Parameters.Add("KAAPSEUDO", OracleType.NVarChar).Value = dwData["KAAPSEUDO"].ToString(); 
          or1.Parameters.Add("KAAURKANR", OracleType.NVarChar).Value = dwData["KAAURKANR"].ToString(); 
          or1.Parameters.Add("KAAURKAPOS", OracleType.NVarChar).Value = dwData["KAAURKAPOS"].ToString(); 
          or1.Parameters.Add("KAAZWECK", OracleType.NVarChar).Value = dwData["KAAZWECK"].ToString(); 
          or1.Parameters.Add("KAAVER", OracleType.NVarChar).Value = dwData["KAAVER"].ToString(); 
          or1.Parameters.Add("KAASTUFE", OracleType.NVarChar).Value = dwData["KAASTUFE"].ToString(); 
          or1.Parameters.Add("KAAPRTKZ", OracleType.NVarChar).Value = dwData["KAAPRTKZ"].ToString(); 
          or1.Parameters.Add("KAASCHEMA", OracleType.NVarChar).Value = dwData["KAASCHEMA"].ToString(); 
          or1.Parameters.Add("KAASVZL", OracleType.NVarChar).Value = dwData["KAASVZL"].ToString(); 
          or1.Parameters.Add("KAAKZWECK", OracleType.NVarChar).Value = dwData["KAAKZWECK"].ToString(); 
          or1.Parameters.Add("KAAKZWVER", OracleType.NVarChar).Value = dwData["KAAKZWVER"].ToString(); 
          or1.Parameters.Add("KAAKZWVZL", OracleType.NVarChar).Value = dwData["KAAKZWVZL"].ToString(); 
          or1.Parameters.Add("KAAFREZKZ", OracleType.NVarChar).Value = dwData["KAAFREZKZ"].ToString(); 
          or1.Parameters.Add("KAADREZKZ", OracleType.NVarChar).Value = dwData["KAADREZKZ"].ToString(); 
          or1.Parameters.Add("KAABREZKZ", OracleType.NVarChar).Value = dwData["KAABREZKZ"].ToString(); 
          or1.Parameters.Add("KAAVWKZ", OracleType.NVarChar).Value = dwData["KAAVWKZ"].ToString(); 
          or1.Parameters.Add("KAAVWKANR", OracleType.NVarChar).Value = dwData["KAAVWKANR"].ToString(); 
          or1.Parameters.Add("KAAVWKAPOS", OracleType.NVarChar).Value = dwData["KAAVWKAPOS"].ToString(); 
          or1.Parameters.Add("KAAAKTKZ", OracleType.NVarChar).Value = dwData["KAAAKTKZ"].ToString(); 
          or1.Parameters.Add("KAAKZSTD", OracleType.NVarChar).Value = dwData["KAAKZSTD"].ToString(); 
          or1.Parameters.Add("KAAAUFKRS", OracleType.NVarChar).Value = dwData["KAAAUFKRS"].ToString(); 
          or1.Parameters.Add("KAAAUFLFD", OracleType.NVarChar).Value = dwData["KAAAUFLFD"].ToString(); 
          or1.Parameters.Add("KAAAUFPOS", OracleType.NVarChar).Value = dwData["KAAAUFPOS"].ToString(); 
          or1.Parameters.Add("KAAKAKUNDNR", OracleType.NVarChar).Value = dwData["KAAKAKUNDNR"].ToString(); 
          or1.Parameters.Add("KAASCHBRT", OracleType.NVarChar).Value = dwData["KAASCHBRT"].ToString(); 
          or1.Parameters.Add("KAASCHLG", OracleType.NVarChar).Value = dwData["KAASCHLG"].ToString(); 
          or1.Parameters.Add("KAAWRI", OracleType.NVarChar).Value = dwData["KAAWRI"].ToString(); 
          or1.Parameters.Add("KAALANDI", OracleType.NVarChar).Value = dwData["KAALANDI"].ToString(); 
          or1.Parameters.Add("KAAWRE", OracleType.NVarChar).Value = dwData["KAAWRE"].ToString(); 
          or1.Parameters.Add("KAALANDE", OracleType.NVarChar).Value = dwData["KAALANDE"].ToString(); 
          or1.Parameters.Add("KAAVERPZI", OracleType.NVarChar).Value = dwData["KAAVERPZI"].ToString(); 
          or1.Parameters.Add("KAAVERPZE", OracleType.NVarChar).Value = dwData["KAAVERPZE"].ToString(); 
          or1.Parameters.Add("KAAVERSZI", OracleType.NVarChar).Value = dwData["KAAVERSZI"].ToString(); 
          or1.Parameters.Add("KAAVERSZE", OracleType.NVarChar).Value = dwData["KAAVERSZE"].ToString(); 
          or1.Parameters.Add("KAAFRAZI", OracleType.NVarChar).Value = dwData["KAAFRAZI"].ToString(); 
          or1.Parameters.Add("KAAFRAZE", OracleType.NVarChar).Value = dwData["KAAFRAZE"].ToString(); 
          or1.Parameters.Add("KAAZOLLZI", OracleType.NVarChar).Value = dwData["KAAZOLLZI"].ToString(); 
          or1.Parameters.Add("KAAZOLLZE", OracleType.NVarChar).Value = dwData["KAAZOLLZE"].ToString(); 
          or1.Parameters.Add("KAAPROVZI", OracleType.NVarChar).Value = dwData["KAAPROVZI"].ToString(); 
          or1.Parameters.Add("KAAPROVZE", OracleType.NVarChar).Value = dwData["KAAPROVZE"].ToString(); 
          or1.Parameters.Add("KAABONZI", OracleType.NVarChar).Value = dwData["KAABONZI"].ToString(); 
          or1.Parameters.Add("KAABONZE", OracleType.NVarChar).Value = dwData["KAABONZE"].ToString(); 
          or1.Parameters.Add("KAASKTZI", OracleType.NVarChar).Value = dwData["KAASKTZI"].ToString(); 
          or1.Parameters.Add("KAASKTZE", OracleType.NVarChar).Value = dwData["KAASKTZE"].ToString(); 
          or1.Parameters.Add("KAAEVZI", OracleType.NVarChar).Value = dwData["KAAEVZI"].ToString(); 
          or1.Parameters.Add("KAAEVZE", OracleType.NVarChar).Value = dwData["KAAEVZE"].ToString(); 
          or1.Parameters.Add("KAASEKSZI", OracleType.NVarChar).Value = dwData["KAASEKSZI"].ToString(); 
          or1.Parameters.Add("KAASEKSZE", OracleType.NVarChar).Value = dwData["KAASEKSZE"].ToString(); 
          or1.Parameters.Add("KAASDBZI", OracleType.NVarChar).Value = dwData["KAASDBZI"].ToString(); 
          or1.Parameters.Add("KAASDBZE", OracleType.NVarChar).Value = dwData["KAASDBZE"].ToString(); 
          or1.Parameters.Add("KAAZINSZI", OracleType.NVarChar).Value = dwData["KAAZINSZI"].ToString(); 
          or1.Parameters.Add("KAAZINSZE", OracleType.NVarChar).Value = dwData["KAAZINSZE"].ToString(); 
          or1.Parameters.Add("KAAWAKZ", OracleType.NVarChar).Value = dwData["KAAWAKZ"].ToString(); 
          or1.Parameters.Add("KAAKUNDNR", OracleType.NVarChar).Value = dwData["KAAKUNDNR"].ToString(); 
          or1.Parameters.Add("KAAWERK", OracleType.NVarChar).Value = dwData["KAAWERK"].ToString(); 
          or1.Parameters.Add("KAAABT", OracleType.NVarChar).Value = dwData["KAAABT"].ToString(); 
          or1.Parameters.Add("KAAART", OracleType.NVarChar).Value = dwData["KAAART"].ToString(); 
          or1.Parameters.Add("KAAVAR", OracleType.NVarChar).Value = dwData["KAAVAR"].ToString(); 
          or1.Parameters.Add("KAAFARBG", OracleType.NVarChar).Value = dwData["KAAFARBG"].ToString(); 
          or1.Parameters.Add("KAADESSG", OracleType.NVarChar).Value = dwData["KAADESSG"].ToString(); 
          or1.Parameters.Add("KAABESG", OracleType.NVarChar).Value = dwData["KAABESG"].ToString(); 
          or1.Parameters.Add("KAAFARBE", OracleType.NVarChar).Value = dwData["KAAFARBE"].ToString(); 
          or1.Parameters.Add("KAADESS", OracleType.NVarChar).Value = dwData["KAADESS"].ToString(); 
          or1.Parameters.Add("KAACOL", OracleType.NVarChar).Value = dwData["KAACOL"].ToString(); 
          or1.Parameters.Add("KAABESCHI", OracleType.NVarChar).Value = dwData["KAABESCHI"].ToString(); 
          or1.Parameters.Add("KAAFARBS", OracleType.NVarChar).Value = dwData["KAAFARBS"].ToString(); 
          or1.Parameters.Add("KAADESSS", OracleType.NVarChar).Value = dwData["KAADESSS"].ToString(); 
          or1.Parameters.Add("KAACOLS", OracleType.NVarChar).Value = dwData["KAACOLS"].ToString(); 
          or1.Parameters.Add("KAABESS", OracleType.NVarChar).Value = dwData["KAABESS"].ToString(); 
          or1.Parameters.Add("KAAHK1", OracleType.NVarChar).Value = dwData["KAAHK1"].ToString(); 
          or1.Parameters.Add("KAAHK2", OracleType.NVarChar).Value = dwData["KAAHK2"].ToString(); 
          or1.Parameters.Add("KAAHK3", OracleType.NVarChar).Value = dwData["KAAHK3"].ToString(); 
          or1.Parameters.Add("KAAHK4", OracleType.NVarChar).Value = dwData["KAAHK4"].ToString(); 
          or1.Parameters.Add("KAAHK5", OracleType.NVarChar).Value = dwData["KAAHK5"].ToString(); 
          or1.Parameters.Add("KAAHK6", OracleType.NVarChar).Value = dwData["KAAHK6"].ToString(); 
          or1.Parameters.Add("KAAFE1", OracleType.NVarChar).Value = dwData["KAAFE1"].ToString(); 
          or1.Parameters.Add("KAAFE2", OracleType.NVarChar).Value = dwData["KAAFE2"].ToString(); 
          or1.Parameters.Add("KAAFE3", OracleType.NVarChar).Value = dwData["KAAFE3"].ToString(); 
          or1.Parameters.Add("KAAFE4", OracleType.NVarChar).Value = dwData["KAAFE4"].ToString(); 
          or1.Parameters.Add("KAAFE5", OracleType.NVarChar).Value = dwData["KAAFE5"].ToString(); 
          or1.Parameters.Add("KAAFE6", OracleType.NVarChar).Value = dwData["KAAFE6"].ToString(); 
          or1.Parameters.Add("KAAFE7", OracleType.NVarChar).Value = dwData["KAAFE7"].ToString(); 
          or1.Parameters.Add("KAAFE8", OracleType.NVarChar).Value = dwData["KAAFE8"].ToString(); 
          or1.Parameters.Add("KAAFE9", OracleType.NVarChar).Value = dwData["KAAFE9"].ToString(); 
          or1.Parameters.Add("KAAFE10", OracleType.NVarChar).Value = dwData["KAAFE10"].ToString(); 
          or1.Parameters.Add("KAAMKKG", OracleType.NVarChar).Value = dwData["KAAMKKG"].ToString(); 
          or1.Parameters.Add("KAAMGKKG1", OracleType.NVarChar).Value = dwData["KAAMGKKG1"].ToString(); 
          or1.Parameters.Add("KAAMGKKG2", OracleType.NVarChar).Value = dwData["KAAMGKKG2"].ToString(); 
          or1.Parameters.Add("KAAMGKKG3", OracleType.NVarChar).Value = dwData["KAAMGKKG3"].ToString(); 
          or1.Parameters.Add("KAAMGKKG4", OracleType.NVarChar).Value = dwData["KAAMGKKG4"].ToString(); 
          or1.Parameters.Add("KAAMGKKG5", OracleType.NVarChar).Value = dwData["KAAMGKKG5"].ToString(); 
          or1.Parameters.Add("KAAMGKKG6", OracleType.NVarChar).Value = dwData["KAAMGKKG6"].ToString(); 
          or1.Parameters.Add("KAAMKSG", OracleType.NVarChar).Value = dwData["KAAMKSG"].ToString(); 
          or1.Parameters.Add("KAAMGKSG1", OracleType.NVarChar).Value = dwData["KAAMGKSG1"].ToString(); 
          or1.Parameters.Add("KAAMGKSG2", OracleType.NVarChar).Value = dwData["KAAMGKSG2"].ToString(); 
          or1.Parameters.Add("KAAMGKSG3", OracleType.NVarChar).Value = dwData["KAAMGKSG3"].ToString(); 
          or1.Parameters.Add("KAAMGKSG4", OracleType.NVarChar).Value = dwData["KAAMGKSG4"].ToString(); 
          or1.Parameters.Add("KAAMGKSG5", OracleType.NVarChar).Value = dwData["KAAMGKSG5"].ToString(); 
          or1.Parameters.Add("KAAMGKSG6", OracleType.NVarChar).Value = dwData["KAAMGKSG6"].ToString(); 
          or1.Parameters.Add("KAAMKROHW", OracleType.NVarChar).Value = dwData["KAAMKROHW"].ToString(); 
          or1.Parameters.Add("KAAMGKROHW1", OracleType.NVarChar).Value = dwData["KAAMGKROHW1"].ToString(); 
          or1.Parameters.Add("KAAMGKROHW2", OracleType.NVarChar).Value = dwData["KAAMGKROHW2"].ToString(); 
          or1.Parameters.Add("KAAMGKROHW3", OracleType.NVarChar).Value = dwData["KAAMGKROHW3"].ToString(); 
          or1.Parameters.Add("KAAMGKROHW4", OracleType.NVarChar).Value = dwData["KAAMGKROHW4"].ToString(); 
          or1.Parameters.Add("KAAMGKROHW5", OracleType.NVarChar).Value = dwData["KAAMGKROHW5"].ToString(); 
          or1.Parameters.Add("KAAMGKROHW6", OracleType.NVarChar).Value = dwData["KAAMGKROHW6"].ToString(); 
          or1.Parameters.Add("KAAMKREZ", OracleType.NVarChar).Value = dwData["KAAMKREZ"].ToString(); 
          or1.Parameters.Add("KAAMGKREZ1", OracleType.NVarChar).Value = dwData["KAAMGKREZ1"].ToString(); 
          or1.Parameters.Add("KAAMGKREZ2", OracleType.NVarChar).Value = dwData["KAAMGKREZ2"].ToString(); 
          or1.Parameters.Add("KAAMGKREZ3", OracleType.NVarChar).Value = dwData["KAAMGKREZ3"].ToString(); 
          or1.Parameters.Add("KAAMGKREZ4", OracleType.NVarChar).Value = dwData["KAAMGKREZ4"].ToString(); 
          or1.Parameters.Add("KAAMGKREZ5", OracleType.NVarChar).Value = dwData["KAAMGKREZ5"].ToString(); 
          or1.Parameters.Add("KAAMGKREZ6", OracleType.NVarChar).Value = dwData["KAAMGKREZ6"].ToString(); 
          or1.Parameters.Add("KAAMKZU", OracleType.NVarChar).Value = dwData["KAAMKZU"].ToString(); 
          or1.Parameters.Add("KAAMGKZU1", OracleType.NVarChar).Value = dwData["KAAMGKZU1"].ToString(); 
          or1.Parameters.Add("KAAMGKZU2", OracleType.NVarChar).Value = dwData["KAAMGKZU2"].ToString(); 
          or1.Parameters.Add("KAAMGKZU3", OracleType.NVarChar).Value = dwData["KAAMGKZU3"].ToString(); 
          or1.Parameters.Add("KAAMGKZU4", OracleType.NVarChar).Value = dwData["KAAMGKZU4"].ToString(); 
          or1.Parameters.Add("KAAMGKZU5", OracleType.NVarChar).Value = dwData["KAAMGKZU5"].ToString(); 
          or1.Parameters.Add("KAAMGKZU6", OracleType.NVarChar).Value = dwData["KAAMGKZU6"].ToString(); 
          or1.Parameters.Add("KAAMKSO", OracleType.NVarChar).Value = dwData["KAAMKSO"].ToString(); 
          or1.Parameters.Add("KAAMGKSO1", OracleType.NVarChar).Value = dwData["KAAMGKSO1"].ToString(); 
          or1.Parameters.Add("KAAMGKSO2", OracleType.NVarChar).Value = dwData["KAAMGKSO2"].ToString(); 
          or1.Parameters.Add("KAAMGKSO3", OracleType.NVarChar).Value = dwData["KAAMGKSO3"].ToString(); 
          or1.Parameters.Add("KAAMGKSO4", OracleType.NVarChar).Value = dwData["KAAMGKSO4"].ToString(); 
          or1.Parameters.Add("KAAMGKSO5", OracleType.NVarChar).Value = dwData["KAAMGKSO5"].ToString(); 
          or1.Parameters.Add("KAAMGKSO6", OracleType.NVarChar).Value = dwData["KAAMGKSO6"].ToString(); 
          or1.Parameters.Add("KAAFFKG", OracleType.NVarChar).Value = dwData["KAAFFKG"].ToString(); 
          or1.Parameters.Add("KAAFEKG1", OracleType.NVarChar).Value = dwData["KAAFEKG1"].ToString(); 
          or1.Parameters.Add("KAAFEKG2", OracleType.NVarChar).Value = dwData["KAAFEKG2"].ToString(); 
          or1.Parameters.Add("KAAFEKG3", OracleType.NVarChar).Value = dwData["KAAFEKG3"].ToString(); 
          or1.Parameters.Add("KAAFEKG4", OracleType.NVarChar).Value = dwData["KAAFEKG4"].ToString(); 
          or1.Parameters.Add("KAAFEKG5", OracleType.NVarChar).Value = dwData["KAAFEKG5"].ToString(); 
          or1.Parameters.Add("KAASEKG", OracleType.NVarChar).Value = dwData["KAASEKG"].ToString(); 
          or1.Parameters.Add("KAAFFKK", OracleType.NVarChar).Value = dwData["KAAFFKK"].ToString(); 
          or1.Parameters.Add("KAAFEKK1", OracleType.NVarChar).Value = dwData["KAAFEKK1"].ToString(); 
          or1.Parameters.Add("KAAFEKK2", OracleType.NVarChar).Value = dwData["KAAFEKK2"].ToString(); 
          or1.Parameters.Add("KAAFEKK3", OracleType.NVarChar).Value = dwData["KAAFEKK3"].ToString(); 
          or1.Parameters.Add("KAAFEKK4", OracleType.NVarChar).Value = dwData["KAAFEKK4"].ToString(); 
          or1.Parameters.Add("KAAFEKK5", OracleType.NVarChar).Value = dwData["KAAFEKK5"].ToString(); 
          or1.Parameters.Add("KAASEKK", OracleType.NVarChar).Value = dwData["KAASEKK"].ToString(); 
          or1.Parameters.Add("KAAFFKROHW", OracleType.NVarChar).Value = dwData["KAAFFKROHW"].ToString(); 
          or1.Parameters.Add("KAAFEKROHW1", OracleType.NVarChar).Value = dwData["KAAFEKROHW1"].ToString(); 
          or1.Parameters.Add("KAAFEKROHW2", OracleType.NVarChar).Value = dwData["KAAFEKROHW2"].ToString(); 
          or1.Parameters.Add("KAAFEKROHW3", OracleType.NVarChar).Value = dwData["KAAFEKROHW3"].ToString(); 
          or1.Parameters.Add("KAAFEKROHW4", OracleType.NVarChar).Value = dwData["KAAFEKROHW4"].ToString(); 
          or1.Parameters.Add("KAAFEKROHW5", OracleType.NVarChar).Value = dwData["KAAFEKROHW5"].ToString(); 
          or1.Parameters.Add("KAASEKROHW", OracleType.NVarChar).Value = dwData["KAASEKROHW"].ToString(); 
          or1.Parameters.Add("KAAFFKV", OracleType.NVarChar).Value = dwData["KAAFFKV"].ToString(); 
          or1.Parameters.Add("KAAFEKV1", OracleType.NVarChar).Value = dwData["KAAFEKV1"].ToString(); 
          or1.Parameters.Add("KAAFEKV2", OracleType.NVarChar).Value = dwData["KAAFEKV2"].ToString(); 
          or1.Parameters.Add("KAAFEKV3", OracleType.NVarChar).Value = dwData["KAAFEKV3"].ToString(); 
          or1.Parameters.Add("KAAFEKV4", OracleType.NVarChar).Value = dwData["KAAFEKV4"].ToString(); 
          or1.Parameters.Add("KAAFEKV5", OracleType.NVarChar).Value = dwData["KAAFEKV5"].ToString(); 
          or1.Parameters.Add("KAASEKV", OracleType.NVarChar).Value = dwData["KAASEKV"].ToString(); 
          or1.Parameters.Add("KAAFFKKONF", OracleType.NVarChar).Value = dwData["KAAFFKKONF"].ToString(); 
          or1.Parameters.Add("KAAFEKKONF1", OracleType.NVarChar).Value = dwData["KAAFEKKONF1"].ToString(); 
          or1.Parameters.Add("KAAFEKKONF2", OracleType.NVarChar).Value = dwData["KAAFEKKONF2"].ToString(); 
          or1.Parameters.Add("KAAFEKKONF3", OracleType.NVarChar).Value = dwData["KAAFEKKONF3"].ToString(); 
          or1.Parameters.Add("KAAFEKKONF4", OracleType.NVarChar).Value = dwData["KAAFEKKONF4"].ToString(); 
          or1.Parameters.Add("KAAFEKKONF5", OracleType.NVarChar).Value = dwData["KAAFEKKONF5"].ToString(); 
          or1.Parameters.Add("KAASEKKONF", OracleType.NVarChar).Value = dwData["KAASEKKONF"].ToString(); 
          or1.Parameters.Add("KAAVVGKTOT1", OracleType.NVarChar).Value = dwData["KAAVVGKTOT1"].ToString(); 
          or1.Parameters.Add("KAAVVGK1", OracleType.NVarChar).Value = dwData["KAAVVGK1"].ToString(); 
          or1.Parameters.Add("KAAVVGK2", OracleType.NVarChar).Value = dwData["KAAVVGK2"].ToString(); 
          or1.Parameters.Add("KAAVVGK3", OracleType.NVarChar).Value = dwData["KAAVVGK3"].ToString(); 
          or1.Parameters.Add("KAAVVGK4", OracleType.NVarChar).Value = dwData["KAAVVGK4"].ToString(); 
          or1.Parameters.Add("KAAVVGK5", OracleType.NVarChar).Value = dwData["KAAVVGK5"].ToString(); 
          or1.Parameters.Add("KAAVVGKTOT2", OracleType.NVarChar).Value = dwData["KAAVVGKTOT2"].ToString(); 
          or1.Parameters.Add("KAALAEV", OracleType.NVarChar).Value = dwData["KAALAEV"].ToString(); 
          or1.Parameters.Add("KAALAETOT1", OracleType.NVarChar).Value = dwData["KAALAETOT1"].ToString(); 
          or1.Parameters.Add("KAALAETOT2", OracleType.NVarChar).Value = dwData["KAALAETOT2"].ToString(); 
          or1.Parameters.Add("KAALAETOT3", OracleType.NVarChar).Value = dwData["KAALAETOT3"].ToString(); 
          or1.Parameters.Add("KAALAETOT4", OracleType.NVarChar).Value = dwData["KAALAETOT4"].ToString(); 
          or1.Parameters.Add("KAALAETOT5", OracleType.NVarChar).Value = dwData["KAALAETOT5"].ToString(); 
          or1.Parameters.Add("KAALAEG", OracleType.NVarChar).Value = dwData["KAALAEG"].ToString(); 
          or1.Parameters.Add("KAAWAGV", OracleType.NVarChar).Value = dwData["KAAWAGV"].ToString(); 
          or1.Parameters.Add("KAAWAGTOT1", OracleType.NVarChar).Value = dwData["KAAWAGTOT1"].ToString(); 
          or1.Parameters.Add("KAAWAGTOT2", OracleType.NVarChar).Value = dwData["KAAWAGTOT2"].ToString(); 
          or1.Parameters.Add("KAAWAGTOT3", OracleType.NVarChar).Value = dwData["KAAWAGTOT3"].ToString(); 
          or1.Parameters.Add("KAAWAGTOT4", OracleType.NVarChar).Value = dwData["KAAWAGTOT4"].ToString(); 
          or1.Parameters.Add("KAAWAGTOT5", OracleType.NVarChar).Value = dwData["KAAWAGTOT5"].ToString(); 
          or1.Parameters.Add("KAAWAGG", OracleType.NVarChar).Value = dwData["KAAWAGG"].ToString(); 
          or1.Parameters.Add("KAAMEZV", OracleType.NVarChar).Value = dwData["KAAMEZV"].ToString(); 
          or1.Parameters.Add("KAAMEZTOT1", OracleType.NVarChar).Value = dwData["KAAMEZTOT1"].ToString(); 
          or1.Parameters.Add("KAAMEZTOT2", OracleType.NVarChar).Value = dwData["KAAMEZTOT2"].ToString(); 
          or1.Parameters.Add("KAAMEZTOT3", OracleType.NVarChar).Value = dwData["KAAMEZTOT3"].ToString(); 
          or1.Parameters.Add("KAAMEZTOT4", OracleType.NVarChar).Value = dwData["KAAMEZTOT4"].ToString(); 
          or1.Parameters.Add("KAAMEZTOT5", OracleType.NVarChar).Value = dwData["KAAMEZTOT5"].ToString(); 
          or1.Parameters.Add("KAAMEZG", OracleType.NVarChar).Value = dwData["KAAMEZG"].ToString(); 
          or1.Parameters.Add("KAARESERVE1", OracleType.NVarChar).Value = dwData["KAARESERVE1"].ToString(); 
          or1.Parameters.Add("KAARESERVE21", OracleType.NVarChar).Value = dwData["KAARESERVE21"].ToString(); 
          or1.Parameters.Add("KAARESERVE22", OracleType.NVarChar).Value = dwData["KAARESERVE22"].ToString(); 
          or1.Parameters.Add("KAARESERVE23", OracleType.NVarChar).Value = dwData["KAARESERVE23"].ToString(); 
          or1.Parameters.Add("KAARESERVE24", OracleType.NVarChar).Value = dwData["KAARESERVE24"].ToString(); 
          or1.Parameters.Add("KAARESERVE25", OracleType.NVarChar).Value = dwData["KAARESERVE25"].ToString(); 
          or1.Parameters.Add("KAARESERVE3", OracleType.NVarChar).Value = dwData["KAARESERVE3"].ToString(); 
          or1.Parameters.Add("KAAKOGRP1", OracleType.NVarChar).Value = dwData["KAAKOGRP1"].ToString(); 
          or1.Parameters.Add("KAAVVGKBTR1", OracleType.NVarChar).Value = dwData["KAAVVGKBTR1"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT11", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT11"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT12", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT12"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT13", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT13"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT14", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT14"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT15", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT15"].ToString(); 
          or1.Parameters.Add("KAAKOGRP2", OracleType.NVarChar).Value = dwData["KAAKOGRP2"].ToString(); 
          or1.Parameters.Add("KAAVVGKBTR2", OracleType.NVarChar).Value = dwData["KAAVVGKBTR2"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT21", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT21"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT22", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT22"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT23", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT23"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT24", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT24"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT25", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT25"].ToString(); 
          or1.Parameters.Add("KAAKOGRP3", OracleType.NVarChar).Value = dwData["KAAKOGRP3"].ToString(); 
          or1.Parameters.Add("KAAVVGKBTR3", OracleType.NVarChar).Value = dwData["KAAVVGKBTR3"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT31", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT31"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT32", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT32"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT33", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT33"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT34", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT34"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT35", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT35"].ToString(); 
          or1.Parameters.Add("KAAKOGRP4", OracleType.NVarChar).Value = dwData["KAAKOGRP4"].ToString(); 
          or1.Parameters.Add("KAAVVGKBTR4", OracleType.NVarChar).Value = dwData["KAAVVGKBTR4"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT41", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT41"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT42", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT42"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT43", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT43"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT44", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT44"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT45", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT45"].ToString(); 
          or1.Parameters.Add("KAAKOGRP5", OracleType.NVarChar).Value = dwData["KAAKOGRP5"].ToString(); 
          or1.Parameters.Add("KAAVVGKBTR5", OracleType.NVarChar).Value = dwData["KAAVVGKBTR5"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT51", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT51"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT52", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT52"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT53", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT53"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT54", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT54"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT55", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT55"].ToString(); 
          or1.Parameters.Add("KAAKOGRP6", OracleType.NVarChar).Value = dwData["KAAKOGRP6"].ToString(); 
          or1.Parameters.Add("KAAVVGKBTR6", OracleType.NVarChar).Value = dwData["KAAVVGKBTR6"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT61", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT61"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT62", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT62"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT63", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT63"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT64", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT64"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT65", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT65"].ToString(); 
          or1.Parameters.Add("KAAKOGRP7", OracleType.NVarChar).Value = dwData["KAAKOGRP7"].ToString(); 
          or1.Parameters.Add("KAAVVGKBTR7", OracleType.NVarChar).Value = dwData["KAAVVGKBTR7"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT71", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT71"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT72", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT72"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT73", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT73"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT74", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT74"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT75", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT75"].ToString(); 
          or1.Parameters.Add("KAAKOGRP8", OracleType.NVarChar).Value = dwData["KAAKOGRP8"].ToString(); 
          or1.Parameters.Add("KAAVVGKBTR8", OracleType.NVarChar).Value = dwData["KAAVVGKBTR8"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT81", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT81"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT82", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT82"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT83", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT83"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT84", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT84"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT85", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT85"].ToString(); 
          or1.Parameters.Add("KAAKOGRP9", OracleType.NVarChar).Value = dwData["KAAKOGRP9"].ToString(); 
          or1.Parameters.Add("KAAVVGKBTR9", OracleType.NVarChar).Value = dwData["KAAVVGKBTR9"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT91", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT91"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT92", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT92"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT93", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT93"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT94", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT94"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT95", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT95"].ToString(); 
          or1.Parameters.Add("KAAKOGRP10", OracleType.NVarChar).Value = dwData["KAAKOGRP10"].ToString(); 
          or1.Parameters.Add("KAAVVGKBTR10", OracleType.NVarChar).Value = dwData["KAAVVGKBTR10"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT101", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT101"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT102", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT102"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT103", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT103"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT104", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT104"].ToString(); 
          or1.Parameters.Add("KAAVVGKAUFT105", OracleType.NVarChar).Value = dwData["KAAVVGKAUFT105"].ToString(); 
          or1.Parameters.Add("KAAFGKG1", OracleType.NVarChar).Value = dwData["KAAFGKG1"].ToString(); 
          or1.Parameters.Add("KAAFGKG2", OracleType.NVarChar).Value = dwData["KAAFGKG2"].ToString(); 
          or1.Parameters.Add("KAAFGKG3", OracleType.NVarChar).Value = dwData["KAAFGKG3"].ToString(); 
          or1.Parameters.Add("KAAFGKG4", OracleType.NVarChar).Value = dwData["KAAFGKG4"].ToString(); 
          or1.Parameters.Add("KAAFGKG5", OracleType.NVarChar).Value = dwData["KAAFGKG5"].ToString(); 
          or1.Parameters.Add("KAAFGKK1", OracleType.NVarChar).Value = dwData["KAAFGKK1"].ToString(); 
          or1.Parameters.Add("KAAFGKK2", OracleType.NVarChar).Value = dwData["KAAFGKK2"].ToString(); 
          or1.Parameters.Add("KAAFGKK3", OracleType.NVarChar).Value = dwData["KAAFGKK3"].ToString(); 
          or1.Parameters.Add("KAAFGKK4", OracleType.NVarChar).Value = dwData["KAAFGKK4"].ToString(); 
          or1.Parameters.Add("KAAFGKK5", OracleType.NVarChar).Value = dwData["KAAFGKK5"].ToString(); 
          or1.Parameters.Add("KAAFGKROHW1", OracleType.NVarChar).Value = dwData["KAAFGKROHW1"].ToString(); 
          or1.Parameters.Add("KAAFGKROHW2", OracleType.NVarChar).Value = dwData["KAAFGKROHW2"].ToString(); 
          or1.Parameters.Add("KAAFGKROHW3", OracleType.NVarChar).Value = dwData["KAAFGKROHW3"].ToString(); 
          or1.Parameters.Add("KAAFGKROHW4", OracleType.NVarChar).Value = dwData["KAAFGKROHW4"].ToString(); 
          or1.Parameters.Add("KAAFGKROHW5", OracleType.NVarChar).Value = dwData["KAAFGKROHW5"].ToString(); 
          or1.Parameters.Add("KAAFGKV1", OracleType.NVarChar).Value = dwData["KAAFGKV1"].ToString(); 
          or1.Parameters.Add("KAAFGKV2", OracleType.NVarChar).Value = dwData["KAAFGKV2"].ToString(); 
          or1.Parameters.Add("KAAFGKV3", OracleType.NVarChar).Value = dwData["KAAFGKV3"].ToString(); 
          or1.Parameters.Add("KAAFGKV4", OracleType.NVarChar).Value = dwData["KAAFGKV4"].ToString(); 
          or1.Parameters.Add("KAAFGKV5", OracleType.NVarChar).Value = dwData["KAAFGKV5"].ToString(); 
          or1.Parameters.Add("KAAFGKKONF1", OracleType.NVarChar).Value = dwData["KAAFGKKONF1"].ToString(); 
          or1.Parameters.Add("KAAFGKKONF2", OracleType.NVarChar).Value = dwData["KAAFGKKONF2"].ToString(); 
          or1.Parameters.Add("KAAFGKKONF3", OracleType.NVarChar).Value = dwData["KAAFGKKONF3"].ToString(); 
          or1.Parameters.Add("KAAFGKKONF4", OracleType.NVarChar).Value = dwData["KAAFGKKONF4"].ToString(); 
          or1.Parameters.Add("KAAFGKKONF5", OracleType.NVarChar).Value = dwData["KAAFGKKONF5"].ToString(); 
          or1.Parameters.Add("KAAVERPI", OracleType.NVarChar).Value = dwData["KAAVERPI"].ToString(); 
          or1.Parameters.Add("KAAVERPE", OracleType.NVarChar).Value = dwData["KAAVERPE"].ToString(); 
          or1.Parameters.Add("KAAVERSI", OracleType.NVarChar).Value = dwData["KAAVERSI"].ToString(); 
          or1.Parameters.Add("KAAVERSE", OracleType.NVarChar).Value = dwData["KAAVERSE"].ToString(); 
          or1.Parameters.Add("KAAFRAI", OracleType.NVarChar).Value = dwData["KAAFRAI"].ToString(); 
          or1.Parameters.Add("KAAFRAE", OracleType.NVarChar).Value = dwData["KAAFRAE"].ToString(); 
          or1.Parameters.Add("KAAZOLLI", OracleType.NVarChar).Value = dwData["KAAZOLLI"].ToString(); 
          or1.Parameters.Add("KAAZOLLE", OracleType.NVarChar).Value = dwData["KAAZOLLE"].ToString(); 
          or1.Parameters.Add("KAAPROVI", OracleType.NVarChar).Value = dwData["KAAPROVI"].ToString(); 
          or1.Parameters.Add("KAAPROVE", OracleType.NVarChar).Value = dwData["KAAPROVE"].ToString(); 
          or1.Parameters.Add("KAABONI", OracleType.NVarChar).Value = dwData["KAABONI"].ToString(); 
          or1.Parameters.Add("KAABONE", OracleType.NVarChar).Value = dwData["KAABONE"].ToString(); 
          or1.Parameters.Add("KAASKTI", OracleType.NVarChar).Value = dwData["KAASKTI"].ToString(); 
          or1.Parameters.Add("KAASKTE", OracleType.NVarChar).Value = dwData["KAASKTE"].ToString(); 
          or1.Parameters.Add("KAAEVI", OracleType.NVarChar).Value = dwData["KAAEVI"].ToString(); 
          or1.Parameters.Add("KAAEVE", OracleType.NVarChar).Value = dwData["KAAEVE"].ToString(); 
          or1.Parameters.Add("KAASEKSI", OracleType.NVarChar).Value = dwData["KAASEKSI"].ToString(); 
          or1.Parameters.Add("KAASEKSE", OracleType.NVarChar).Value = dwData["KAASEKSE"].ToString(); 
          or1.Parameters.Add("KAASDBI", OracleType.NVarChar).Value = dwData["KAASDBI"].ToString(); 
          or1.Parameters.Add("KAASDBE", OracleType.NVarChar).Value = dwData["KAASDBE"].ToString(); 
          or1.Parameters.Add("KAAZINSI", OracleType.NVarChar).Value = dwData["KAAZINSI"].ToString(); 
          or1.Parameters.Add("KAAZINSE", OracleType.NVarChar).Value = dwData["KAAZINSE"].ToString(); 
          or1.Parameters.Add("KAASCHK", OracleType.NVarChar).Value = dwData["KAASCHK"].ToString(); 
          or1.Parameters.Add("KAAVERPR", OracleType.NVarChar).Value = dwData["KAAVERPR"].ToString(); 
          or1.Parameters.Add("KAAZUSCHL", OracleType.NVarChar).Value = dwData["KAAZUSCHL"].ToString(); 
          or1.Parameters.Add("KAAVERKPR", OracleType.NVarChar).Value = dwData["KAAVERKPR"].ToString(); 
          or1.Parameters.Add("KAAWBBRT", OracleType.NVarChar).Value = dwData["KAAWBBRT"].ToString(); 
          or1.Parameters.Add("KAAWBF", OracleType.NVarChar).Value = dwData["KAAWBF"].ToString(); 
          or1.Parameters.Add("KAABIND", OracleType.NVarChar).Value = dwData["KAABIND"].ToString(); 
          or1.Parameters.Add("KAARWBRT", OracleType.NVarChar).Value = dwData["KAARWBRT"].ToString(); 
          or1.Parameters.Add("KAARGRLFD", OracleType.NVarChar).Value = dwData["KAARGRLFD"].ToString(); 
          or1.Parameters.Add("KAASCHT", OracleType.NVarChar).Value = dwData["KAASCHT"].ToString(); 
          or1.Parameters.Add("KAAFWBRT", OracleType.NVarChar).Value = dwData["KAAFWBRT"].ToString(); 
          or1.Parameters.Add("KAAFGRLFD", OracleType.NVarChar).Value = dwData["KAAFGRLFD"].ToString(); 
          or1.Parameters.Add("KAALAEAEND", OracleType.NVarChar).Value = dwData["KAALAEAEND"].ToString(); 
          or1.Parameters.Add("KAAMEZ", OracleType.NVarChar).Value = dwData["KAAMEZ"].ToString(); 
          or1.Parameters.Add("KAAWAG", OracleType.NVarChar).Value = dwData["KAAWAG"].ToString(); 
          or1.Parameters.Add("KAAFDDIK", OracleType.NVarChar).Value = dwData["KAAFDDIK"].ToString(); 
          or1.Parameters.Add("KAAFDISM", OracleType.NVarChar).Value = dwData["KAAFDISM"].ToString(); 
          or1.Parameters.Add("KAAFDDIS", OracleType.NVarChar).Value = dwData["KAAFDDIS"].ToString(); 
          or1.Parameters.Add("KAAFDDIM", OracleType.NVarChar).Value = dwData["KAAFDDIM"].ToString(); 
          or1.Parameters.Add("KAAFDDIF", OracleType.NVarChar).Value = dwData["KAAFDDIF"].ToString(); 
          or1.Parameters.Add("KAAFDLGS", OracleType.NVarChar).Value = dwData["KAAFDLGS"].ToString(); 
          or1.Parameters.Add("KAAMFS", OracleType.NVarChar).Value = dwData["KAAMFS"].ToString(); 
          or1.Parameters.Add("KAARSTANT1", OracleType.NVarChar).Value = dwData["KAARSTANT1"].ToString(); 
          or1.Parameters.Add("KAARSTBEZ1", OracleType.NVarChar).Value = dwData["KAARSTBEZ1"].ToString(); 
          or1.Parameters.Add("KAARSTANT2", OracleType.NVarChar).Value = dwData["KAARSTANT2"].ToString(); 
          or1.Parameters.Add("KAARSTBEZ2", OracleType.NVarChar).Value = dwData["KAARSTBEZ2"].ToString(); 
          or1.Parameters.Add("KAARSTANT3", OracleType.NVarChar).Value = dwData["KAARSTANT3"].ToString(); 
          or1.Parameters.Add("KAARSTBEZ3", OracleType.NVarChar).Value = dwData["KAARSTBEZ3"].ToString(); 
          or1.Parameters.Add("KAARSTANT4", OracleType.NVarChar).Value = dwData["KAARSTANT4"].ToString(); 
          or1.Parameters.Add("KAARSTBEZ4", OracleType.NVarChar).Value = dwData["KAARSTBEZ4"].ToString(); 
          or1.Parameters.Add("KAAVB", OracleType.NVarChar).Value = dwData["KAAVB"].ToString(); 
          or1.Parameters.Add("KAAPROGRP", OracleType.NVarChar).Value = dwData["KAAPROGRP"].ToString(); 
          or1.Parameters.Add("KAAARTGRP", OracleType.NVarChar).Value = dwData["KAAARTGRP"].ToString(); 
          or1.Parameters.Add("KAAKALKART", OracleType.NVarChar).Value = dwData["KAAKALKART"].ToString(); 
          or1.Parameters.Add("KAAKALKVAR", OracleType.NVarChar).Value = dwData["KAAKALKVAR"].ToString(); 
          or1.Parameters.Add("KAABRTFAKTOR", OracleType.NVarChar).Value = dwData["KAABRTFAKTOR"].ToString(); 
          or1.Parameters.Add("KAASTUEART", OracleType.NVarChar).Value = dwData["KAASTUEART"].ToString(); 
          or1.Parameters.Add("KAABAHNIG", OracleType.NVarChar).Value = dwData["KAABAHNIG"].ToString(); 
          or1.Parameters.Add("KAAZUKAUF", OracleType.NVarChar).Value = dwData["KAAZUKAUF"].ToString(); 
          or1.Parameters.Add("KAAAPSPERRE", OracleType.NVarChar).Value = dwData["KAAAPSPERRE"].ToString(); 
          or1.Parameters.Add("KAAAPSPERRE2", OracleType.NVarChar).Value = dwData["KAAAPSPERRE2"].ToString(); 
          or1.Parameters.Add("KAAAPSPERRE3", OracleType.NVarChar).Value = dwData["KAAAPSPERRE3"].ToString(); 
          or1.Parameters.Add("KAADART", OracleType.NVarChar).Value = dwData["KAADART"].ToString(); 
          or1.Parameters.Add("KAADVAR", OracleType.NVarChar).Value = dwData["KAADVAR"].ToString(); 
          or1.Parameters.Add("KAAZUSTAND", OracleType.NVarChar).Value = dwData["KAAZUSTAND"].ToString(); 
          or1.Parameters.Add("KAAAUFM", OracleType.NVarChar).Value = dwData["KAAAUFM"].ToString(); 
          or1.Parameters.Add("KAAVERP", OracleType.NVarChar).Value = dwData["KAAVERP"].ToString(); 
          or1.Parameters.Add("KAAZAM", OracleType.NVarChar).Value = dwData["KAAZAM"].ToString(); 
          or1.Parameters.Add("KAAURRENDEM", OracleType.NVarChar).Value = dwData["KAAURRENDEM"].ToString(); 
          or1.Parameters.Add("KAAURRENDEM2", OracleType.NVarChar).Value = dwData["KAAURRENDEM2"].ToString(); 
          or1.Parameters.Add("KAAGSPH", OracleType.NVarChar).Value = dwData["KAAGSPH"].ToString(); 
          or1.Parameters.Add("KAAMMIN", OracleType.NVarChar).Value = dwData["KAAMMIN"].ToString(); 
          or1.Parameters.Add("KAAFILLER", OracleType.NVarChar).Value = dwData["KAAFILLER"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
